package cn.edu.nju.testdb.main;

import cn.edu.nju.testdb.dao.TestDao;
import cn.edu.nju.testdb.dao.impl.TestDaoImpl;

public class Main {
	private static TestDao testDao = new TestDaoImpl();
	public static void main(String[] args) {
		Long beginTime1 = System.currentTimeMillis();
		testDao.sp_RandomInsert(1000000);
		Long cost1 = System.currentTimeMillis()-beginTime1;
		System.out.println("RandomInsertCost:"+cost1/1000.0+"s");
	
		Long beginTime2 = System.currentTimeMillis();
		testDao.executeCountByCol1();
		Long cost2 = System.currentTimeMillis()-beginTime2;
		System.out.println("CountByCol1:"+cost2/1000.0+"s");
		
		Long beginTime3 = System.currentTimeMillis();
		testDao.executeFindByLike();
		Long cost3 = System.currentTimeMillis()-beginTime3;
		System.out.println("CountByCol1:"+cost3/1000.0+"s");

	}
}
